UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2uiXa2wUEBc9CyVclox0sw7ZjgkYd9zjSKlENZcAw9U='
WHERE
key_id = '4afca5ae7d5c873b7bd8d6e5fb95bc6914f95524e1ffde136b64bb6bfc70e767'
AND (
token = '2uiXa2wUEBc9CyVclox0sw7ZjgkYd9zjSKlENZcAw9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)