UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7HBmgwouun5f7w8G6/QyJ8hLG1toFrxsSEB6TOCbCM0='
WHERE
key_id = '02e970d0a64962dfe558cc0acf1529b9013566247f7e6e65935bbc7eb64a4534'
AND (
token = '7HBmgwouun5f7w8G6/QyJ8hLG1toFrxsSEB6TOCbCM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)