UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gS1OtVsNmGgxLcH8t7EZvLTr37LT2u3S4cHXFbxIXd0='
WHERE
key_id = '57d36457614854d52c486a212b98ebe2ead1507549e368f8d03b6b1916cd9289'
AND (
token = 'gS1OtVsNmGgxLcH8t7EZvLTr37LT2u3S4cHXFbxIXd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)