UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nNAc3WIcoDbnD07YPm3DlDm6PxfcB4obkVk4irybTYA='
WHERE
key_id = '929e46c1688310d7ca06f221bf6f7a8b9d4f1d1a54b105c8f032e19d9d7710de'
AND (
token = 'nNAc3WIcoDbnD07YPm3DlDm6PxfcB4obkVk4irybTYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)