UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0L4s1c8+6TeZSo4s3+A9Tq282TDUXwZbRnsCogZ9yB0='
WHERE
key_id = 'bfdd0426721966107147ccf2845787b899458c482e8e5f22a331ce17cb53c3c4'
AND (
token = '0L4s1c8+6TeZSo4s3+A9Tq282TDUXwZbRnsCogZ9yB0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)