UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6tWexMagp/V+0oac5nWk7D7bj/xdvbszKUW+3RV6/yM='
WHERE
key_id = 'e95abb4f97fbbd1e1df04b9293e78b3adb0147c0abcdcb738ab558e03ff433ec'
AND (
token = '6tWexMagp/V+0oac5nWk7D7bj/xdvbszKUW+3RV6/yM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)