UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzauLd/a6ZiGfkbogzetC1jczKkz5wfHBpENfof9qOM='
WHERE
key_id = '2daa5b6d0ae7a708dd405446c5bd341bf0c68d0b8dc9b101af1b874dabc5413f'
AND (
token = 'XzauLd/a6ZiGfkbogzetC1jczKkz5wfHBpENfof9qOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)