UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o/1RFKCWjZl8w2by372q5CEccWyCjUx7fD2b6s+L+t4='
WHERE
key_id = '4c8ccaaca65089720c54831a99f7f7771a78789683bd2fee0dd03012e300dafc'
AND (
token = 'o/1RFKCWjZl8w2by372q5CEccWyCjUx7fD2b6s+L+t4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)