UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7tAJjYUi8lKQBX0pYZ1jb81UACbf0V68nt/VOLRHO4c='
WHERE
key_id = 'a0ad3b4fcb025d0ece5c30f08a7a70aef1c90f73612f9bdd23d98d18882692eb'
AND (
token = '7tAJjYUi8lKQBX0pYZ1jb81UACbf0V68nt/VOLRHO4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)