UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0048Gq/FumxtV81CIDLBYbz4mxuzE+URu+PSCjVw7gk='
WHERE
key_id = 'c842489ed4fa86f59269e01dc79e08d279890343ea162cbb1a54b138b2b05f66'
AND (
token = '0048Gq/FumxtV81CIDLBYbz4mxuzE+URu+PSCjVw7gk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)