UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JhZk16zXfy0h+I+muFAPVCYFwin4CH2keNojuzyiLF8='
WHERE
key_id = '5987a75b07f0935bff52d4dd44b7dd80d69c8552050df54077cfb78880607d1d'
AND (
token = 'JhZk16zXfy0h+I+muFAPVCYFwin4CH2keNojuzyiLF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)