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