UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9xu6jOPRjqTHPfpCon9PX4j7lxT5PNKtxAawlveB5Gk='
WHERE
key_id = 'e9ecd8a5ab8c87e4f8a7c025de60550396859e8236e60b94d1e040b5a52ad576'
AND (
token = '9xu6jOPRjqTHPfpCon9PX4j7lxT5PNKtxAawlveB5Gk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)