UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BLpBNChB9kP80k2aRLqC3rh13EKHTwWSze6q1A12+9o='
WHERE
key_id = 'e430e062ef8a67286ae801431f7326ca3d3c44c85c05db04fc0847d7c9e6031b'
AND (
token = 'BLpBNChB9kP80k2aRLqC3rh13EKHTwWSze6q1A12+9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)