UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm9L0Ny6OTDjOsuHODHY9qn5f+fAnZmjLH6heNM5unMI='
WHERE
key_id = 'd23ce52b488853fa3e9dd062a0d036e15567c3489484b98764eb51031ca725f7'
AND (
token = 'm9L0Ny6OTDjOsuHODHY9qn5f+fAnZmjLH6heNM5unMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)