UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5zmIGC++nPz+JxiDzyF9BVGhovu0ebG/up9ZGhTM6Eg='
WHERE
key_id = '6f4a4253d85e57bbe03c8db4dd5cf36c4cfbef5b1187551ab90e4b4a77b88802'
AND (
token = '5zmIGC++nPz+JxiDzyF9BVGhovu0ebG/up9ZGhTM6Eg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)