UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZGzFNOAv9Ey8bXoVzTHBK8j2yZenf4zdaVUxYE7Q1I='
WHERE
key_id = 'e07ed2c8c0d55da418b087e3c70280b973b7c21d8747347d1504036f6f476c66'
AND (
token = 'hZGzFNOAv9Ey8bXoVzTHBK8j2yZenf4zdaVUxYE7Q1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)