UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IFoLymAa80xDXr0wrJrsHMGoagbVeD7ZKGOiJi2zFSA='
WHERE
key_id = '47b0cca65c3af5718b5da9f403452bb2c67ccb66e8ce27e1dd15f3bdc372c499'
AND (
token = 'IFoLymAa80xDXr0wrJrsHMGoagbVeD7ZKGOiJi2zFSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)