UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7wC6W8W+e/RsIMRzOaZawUJvYpRmgyfTbxeBbttdqMg='
WHERE
key_id = 'd10a061414434e051c5bae92f35aacf42543b3993b53ef4cf807dab0e1d5521f'
AND (
token = '7wC6W8W+e/RsIMRzOaZawUJvYpRmgyfTbxeBbttdqMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)