UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4B9kh6dfEd7ckE8NykpREkCQZKAkP323zeh0GgAVjTk='
WHERE
key_id = '492558338e3fb876dc90345b684cb35e7002756e78ea590501b62ffc2603ca54'
AND (
token = '4B9kh6dfEd7ckE8NykpREkCQZKAkP323zeh0GgAVjTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)