UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NRj5GxreW+gv+K2WgAlsWexHRPYlWyEadtOBsKNFn/o='
WHERE
key_id = 'd1c576e3d6390dca6fb91677a38fe9a1fd0f876665fb4a307ab1653815e0d927'
AND (
token = 'NRj5GxreW+gv+K2WgAlsWexHRPYlWyEadtOBsKNFn/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)