UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'djJN27PD4UE2WOGO36Bj/uyfqH3SQFmPZKrVUnzWddw='
WHERE
key_id = 'd4457ac216ac4b4945d62177e1ad414fdf2227858819ee4fe8b27d9b7bcde428'
AND (
token = 'djJN27PD4UE2WOGO36Bj/uyfqH3SQFmPZKrVUnzWddw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)