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