UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hotf7Ttlocnl/S8k8q4AgZKmyYs2QUPfUJdQLuoAMVo='
WHERE
key_id = 'c367a7b33798d1c78ffdeca7b2896d581f511f41a60fc27bdce8a020becbeead'
AND (
token = 'hotf7Ttlocnl/S8k8q4AgZKmyYs2QUPfUJdQLuoAMVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)