UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3WX5aZi1B7v6ICfrBz3mBJZ8MtWYqMEeaWaFNctWpeI='
WHERE
key_id = 'caa1669a4d91def07e6131adb0fd7bd400ab5bb4b38e9036c88ff2f0f3844565'
AND (
token = '3WX5aZi1B7v6ICfrBz3mBJZ8MtWYqMEeaWaFNctWpeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)