UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KXlgjf9GXYt1BXppsJ6lIzh6YGy84OnoReJIsppDmvM='
WHERE
key_id = '818e925bd016de0b02d21f7005209c8f98d611d04d3459f03eca40b2bc719a8d'
AND (
token = 'KXlgjf9GXYt1BXppsJ6lIzh6YGy84OnoReJIsppDmvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)