UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NPuE7nPESOUYAlkX+kRof9Ayg0ymcflBo8GAoareDNU='
WHERE
key_id = 'd9bce63af3b80888c5340faa6af4294e862361b28020d775b72f861ac5890810'
AND (
token = 'NPuE7nPESOUYAlkX+kRof9Ayg0ymcflBo8GAoareDNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)