UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HoZWJKzRd74jCyiGyw6c3Hf7kZnz/fFQsGfa214hqtw='
WHERE
key_id = 'c638c1e5b6fea02cbe18046c796b41aa0e77e5669df1f4be44e5ab6cef676392'
AND (
token = 'HoZWJKzRd74jCyiGyw6c3Hf7kZnz/fFQsGfa214hqtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)