UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xshzn0pIvuAZ+o7VQGt2yNh/v9enJxTVHCyZhUAjqJA='
WHERE
key_id = '102fe67a9a0ef53aed2cb9ee9ced2e03f51989efc2824684a574fd52f1400de6'
AND (
token = 'xshzn0pIvuAZ+o7VQGt2yNh/v9enJxTVHCyZhUAjqJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)